SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3' and baths >='2') and (bedrooms='3' and baths >='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Set on 11.5 private acres in scenic Plainfield, New Hampshire, this beautifully designed 2021 home offers the perfect balance of comfort, privacy, and modern living. The main living area is warm and welcoming, centered around a striking stone hearth with a propane fireplace. The bright kitchen opens seamlessly to the living and dining areas, creating an easy flow for everyday living and entertaining. An oversized 2-car garage offers direct entry into the home, while a dedicated laundry room and half bath are conveniently tucked just off the kitchen. A spacious wraparound deck expands the living space outdoors, providing a peaceful setting for summer dining, relaxing, and enjoying the surrounding landscape and water views. The primary suite features a beautifully appointed en suite bath and walk-in closet. The finished lower level offers a large sauna, flexible space for a gym, office, media room, or additional living area. A whole-house generator adds year-round peace of mind. Surrounded by nature yet conveniently located with easy access to Hanover, Lebanon, Shopping, Dartmouth College, and Dartmouth Hitchcock Medical Center, this property offers a wonderful blend of privacy, convenience, and Upper Valley living.
Description:Located just a half mile south of the Dartmouth Green, this beautifully updated raised ranch offers the perfect blend of comfort, flexibility, and convenience. Tucked on a level, landscaped lot with lawn space and landscaping, the home provides an easy lifestyle in a truly exceptional location, walkable to downtown, schools, dining, and recreation. The thoughtfully designed main level features three bedrooms--one ensuite with a 3/4 bath and two that share an additional full bath. Sunlight fills the welcoming living room, while the adjoining dining area opens seamlessly onto a deck - ideal for morning coffee or summer BBQs. The updated kitchen offers both style and functionality, creating a warm central gathering space for everyday living. The finished lower level adds remarkable versatility, with a large family room centered around a cozy wood stove, perfect for relaxing evenings or casual entertaining. A full bath, laundry room, dedicated office, and smaller bonus room provide flexible spaces to work, create, or host guests with ease. Direct access to the attached one-car garage adds everyday convenience, especially during New England winters. With recent updates, abundant usable space, and an unbeatable in-town setting, this move-in-ready home offers the rare opportunity to enjoy comfort, character, and walkability in the heart of Hanover. Furnished photos are virtually staged.
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house Fri 7/10 3-5pm and Sat 7/11 10am-12pm
Description:This beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.
Description:Set in a highly sought-after location with easy access to town and nearby trails, this beautifully maintained cape blends comfort, functionality, and convenience. An attached 2-car garage and direct entry add to the home’s everyday ease. Inside, the thoughtfully designed layout begins with a spacious mudroom featuring a walk-in closet and half bath—perfect for staying organized year-round. The open-concept kitchen, dining, and living area creates a natural gathering space, ideal for both daily living and entertaining, with a slider leading out to a private back patio. A dedicated home office offers the flexibility today’s buyers are looking for. Upstairs, you’ll find two generously sized bedrooms and a full bath, along with an oversized primary suite. This inviting retreat features a walk-in closet and an en-suite bath complete with a soaking tub. Convenient second-floor laundry enhances the home’s practical design. The finished lower level provides additional living space with a large family room and full window—perfect for guests, a media room, or a cozy place to unwind. A utility room offers excellent storage or the potential for a small workshop. All of this is just minutes from Dartmouth College and within 10 minutes of Dartmouth-Hitchcock Medical Center. With a level, low-maintenance yard and well manicured perennial gardens, and a location that balances accessibility with outdoor recreation, this home delivers the best of Upper Valley living.